Tabela LBenefitPlanContrBeneficiary

Definicja tabeli LBenefitPlanContrBeneficiary

Name

LBenefitPlanContrBeneficiary

Code

LBenefitPlanContrBeneficiary

Comment

PL: Polaczenie beneficjenta z umowa i benefitplanem – informacja o statusie w benefitplanie umowy
EN: Link between beneficiary and contract's benefitplan – vip status in contact benefitplan


Lista kolumn tabeli LBenefitPlanContrBeneficiary

Name

Code

LBenefitPlanContrBeneficiaryID

LBenefitPlanContrBeneficiaryID

BenefitPlanContractID

BenefitPlanContractID

CareTakerID

CareTakerID

KinshipID

KinshipID

ContractorID

ContractorID

PersonNameInvoice

PersonNameInvoice

StartDT

StartDT

StopDT

StopDT

CardNo

CardNo

CardgenerationDate

CardgenerationDate

BeneficiaryID

BeneficiaryID

Ben_PersonID

Ben_PersonID

isPatientConfirmed

isPatientConfirmed


Kolumna LBenefitPlanContrBeneficiaryID tabeli LBenefitPlanContrBeneficiary

Definicja kolumny LBenefitPlanContrBeneficiaryID tabeli LBenefitPlanContrBeneficiary

Name

LBenefitPlanContrBeneficiaryID

Code

LBenefitPlanContrBeneficiaryID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna BenefitPlanContractID tabeli LBenefitPlanContrBeneficiary

Definicja kolumny BenefitPlanContractID tabeli LBenefitPlanContrBeneficiary

Name

BenefitPlanContractID

Code

BenefitPlanContractID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CareTakerID tabeli LBenefitPlanContrBeneficiary

Definicja kolumny CareTakerID tabeli LBenefitPlanContrBeneficiary

Name

CareTakerID

Code

CareTakerID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna KinshipID tabeli LBenefitPlanContrBeneficiary

Definicja kolumny KinshipID tabeli LBenefitPlanContrBeneficiary

Name

KinshipID

Code

KinshipID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractorID tabeli LBenefitPlanContrBeneficiary

Definicja kolumny ContractorID tabeli LBenefitPlanContrBeneficiary

Name

ContractorID

Code

ContractorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonNameInvoice tabeli LBenefitPlanContrBeneficiary

Definicja kolumny PersonNameInvoice tabeli LBenefitPlanContrBeneficiary

Name

PersonNameInvoice

Code

PersonNameInvoice

Data Type

NUMBER(5)

Mandatory

No

Comment

faktura imienna


Kolumna StartDT tabeli LBenefitPlanContrBeneficiary

Definicja kolumny StartDT tabeli LBenefitPlanContrBeneficiary

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LBenefitPlanContrBeneficiary

Definicja kolumny StopDT tabeli LBenefitPlanContrBeneficiary

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna CardNo tabeli LBenefitPlanContrBeneficiary

Definicja kolumny CardNo tabeli LBenefitPlanContrBeneficiary

Name

CardNo

Code

CardNo

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna CardgenerationDate tabeli LBenefitPlanContrBeneficiary

Definicja kolumny CardgenerationDate tabeli LBenefitPlanContrBeneficiary

Name

CardgenerationDate

Code

CardgenerationDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna BeneficiaryID tabeli LBenefitPlanContrBeneficiary

Definicja kolumny BeneficiaryID tabeli LBenefitPlanContrBeneficiary

Name

BeneficiaryID

Code

BeneficiaryID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Ben_PersonID tabeli LBenefitPlanContrBeneficiary

Definicja kolumny Ben_PersonID tabeli LBenefitPlanContrBeneficiary

Name

Ben_PersonID

Code

Ben_PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna isPatientConfirmed tabeli LBenefitPlanContrBeneficiary

Definicja kolumny isPatientConfirmed tabeli LBenefitPlanContrBeneficiary

Name

isPatientConfirmed

Code

isPatientConfirmed

Data Type

NUMBER(5)

Mandatory

No

Comment

Czy pacjent wyrazil zgode na badanie kliniczne


Lista kluczy tabeli LBenefitPlanContrBeneficiary

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LBenefitPlanContrBeneficiary

Definicja klucza Identifier_1 tabeli LBenefitPlanContrBeneficiary

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment